package com.demo.mapper;

import com.demo.dao.Score;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Component;

import java.util.List;

@Mapper
@Component
public interface ScoreMapper {

//    查询某学期和某班级的所有科目成绩
    List<Score> getScoreByClass(String  classno,String term);
    //通过课程查询
    List<Score> getScoreByCId(String classno,String term,int cid);
    //查询单人的成绩
    List<Score> getScoreBySid(String term,String sid);

    //查询不及格名单
    List<Score> getDisqualified(String classno,String term);

    //按课程查询不及格名单
    List<Score> getDisqualifiedByCid(String classno,String term,int cid);

    void insertScore(Score score);

}
